CS185cSpring 2010Lecture Notes
Fundamentals of IBM DB2 for z/OS
Videos of lectures are
available. As they are on my office machine and I don't want robots to
try to download them, the directory is password protected. The login is
guest and the password is guest.
Below are my lecture notes for the class so far.
They should serve as a rough guide to what was covered on any given day.
Frequently, however, I say more in class than is in these notes.
Also, I tend to dynamically correct typos on the board
that might appear in these lecture notes. So caveat emptor.
Week 1:
[Jan. 26 -- DB2 for z/OS Introduction] [Jan. 28 -- Features, Environment, Tablespaces, Varian Demo]
Week 2:
[Feb. 2 -- DB2 Data Structures] [Feb. 4 -- Finish DB2 Data Structures, More on Tablespaces]
Week 3:
[Feb. 9 -- Finish Table Spaces, Start Architecture] [Feb. 11 -- DB2 Address Space and Architecture]
Week 4:
[Feb. 16 -- DB2 Address Space and Database Services] [Feb. 18 -- More Database Services]
Week 5:
[Feb. 23 -- DB2's access to z/OS Services] [Feb. 25 -- DB2 Attachment Facilities]
Week 6:
[Mar. 2 -- Workload Management] [Mar. 4 --Distributed Data Facility]
Week 7:
[Mar. 9 -- SQL Overview] [Mar 11 -- Practice Midterm Day]
Week 8:
[Mar 16 -- Midterm Day] [Mar 18 -- Furlough Day]
Week 9:
[Mar 23 -- Furlough Day] [Mar. 25 -- SQL]
Week 10:
[Mar 31 -- Spring Break] [Apr 2 -- Spring Break]
Week 11:
[Apr. 6 -- Yet More SQL] [Apr. 8 -- SQL Extensions]
Week 12:
[Apr. 13 -- Static and Dynamic SQL] [Apr. 15 -- DB2 Programming Interface]
Week 13:
[Apr. 20 -- DB2 Security] [Apr. 22 -- More DB2 Security]
Week 14:
[Apr. 27 -- DB2 Concurrency Control]
[Apr. 29 -- Finish Concurrency, Logging and Recovery]
Week 15:
[May 5 -- Finish Logging and Recovery; Startup Restart]
[Faculty Furlough]
Week 16:
[May 11 -- Restart, Commands, Tools, and Utilities]
|